UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZG1F7n7v5HguNZTIdJTf3K11lBrZCUDle8oXjZSEw7Y='
WHERE
key_id = '1107113fb77fc6bdff8b558db22354c87109572a929f696a6b6d68195dbebe62'
AND (
token = 'ZG1F7n7v5HguNZTIdJTf3K11lBrZCUDle8oXjZSEw7Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)