UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xY+VwLp6XKBozZN4n8jLemEjfdOszT9i/Awfp1AlWFM='
WHERE
key_id = '8a3c172c630902c5e27fa84e385e5b8857b28a845c2515e3b469b4935577198a'
AND (
token = 'xY+VwLp6XKBozZN4n8jLemEjfdOszT9i/Awfp1AlWFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)