UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JfDL7WnY2cj/pvny4irt01WeIRF5ZTiu54ICyXZe7Wo='
WHERE
key_id = 'a1170da26625868f16fb5a0ac7d537f3d5922128cb657b3088439b4e6e7f7910'
AND (
token = 'JfDL7WnY2cj/pvny4irt01WeIRF5ZTiu54ICyXZe7Wo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)