UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OCIILGSHKmo9JU9XCg4l6bDenKHhw11J2TmlQPQNwzw='
WHERE
key_id = 'aef8f57904b28d3c285aceefce3597c7e3179e4adcbe681d0d0e9d3a0e641998'
AND (
token = 'OCIILGSHKmo9JU9XCg4l6bDenKHhw11J2TmlQPQNwzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)