UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xJUfVNEENT7ZBxMiVCA+R12MIySOxZ2hRLhW8y9lpuE='
WHERE
key_id = '47e1d93183057c728908597feca28d4e5ac9db87271b1d595258b957e3194281'
AND (
token = 'xJUfVNEENT7ZBxMiVCA+R12MIySOxZ2hRLhW8y9lpuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)