UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XM/G8jvEASE5w/H+DQqoaOZiWldL5lgWdt2ykJwBes0='
WHERE
key_id = '8f4019de3a8a72ea58d0c49bbc2a5ff1921e5db3e9096c01ad72f5a93e7cf41a'
AND (
token = 'XM/G8jvEASE5w/H+DQqoaOZiWldL5lgWdt2ykJwBes0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)