UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3W7tCYA1r4Tj0lh7dnGm7H5VVWqFOMKPpz/M1TIkWsU='
WHERE
key_id = 'fb5153beab8fcf803f0dc161d9bb204586c7e808ab309df4e8b03b76d7a4f9be'
AND (
token = '3W7tCYA1r4Tj0lh7dnGm7H5VVWqFOMKPpz/M1TIkWsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)