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