UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y4zipqdXT9gru2xQT6FocVi8dp4OqtRlMtPlWVIXgj0='
WHERE
key_id = '6c45b83a0f97762c27d5fdfc27cae0e5205148fddadd5e43df332bdd29238ff1'
AND (
token = 'Y4zipqdXT9gru2xQT6FocVi8dp4OqtRlMtPlWVIXgj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)