UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Mv1SbfMl2v13l09C++ZFlA3KjqI84JggAwfLCBM9zA='
WHERE
key_id = 'a5ace3bc41d8abf188dfe4610207bcd138940023bcf6317b6854155a0ec2a4fb'
AND (
token = '2Mv1SbfMl2v13l09C++ZFlA3KjqI84JggAwfLCBM9zA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)