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