UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w4HgsVBn7wq/muyvpvDv0ekP8dk//JN10eDEt6m+MOU='
WHERE
key_id = 'f363ea869b4251ddc177c09c6e0a74ffe946eca803b54d08113c013f31b84d45'
AND (
token = 'w4HgsVBn7wq/muyvpvDv0ekP8dk//JN10eDEt6m+MOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)