UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AGdw1O4ez1oIDCwq6T5StvuNlbxqBKOmtaB7Be6fXwo='
WHERE
key_id = 'f5c2db54634eda3a868cf31d3f127964e43ea93b362e6365105210de6ceffa98'
AND (
token = 'AGdw1O4ez1oIDCwq6T5StvuNlbxqBKOmtaB7Be6fXwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)