UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UAJOX9YmUgLiovw64PMR1WWFBQmcbtjYVgFFzSTffSU='
WHERE
key_id = '5171c94bb35ff3b91fd4a3d248bd0c1b1cd95090d7cbb74a0722b873bc37ba7f'
AND (
token = 'UAJOX9YmUgLiovw64PMR1WWFBQmcbtjYVgFFzSTffSU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)