UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qorj3Xn/s1WGKVqUgM/HqHrkmb0iZDDF4SfzJXW6mX4='
WHERE
key_id = '3ca27c033ec72b1a74e4c84d24fb93dbbdb62195df1e25ae04858e33ff68bf9b'
AND (
token = 'qorj3Xn/s1WGKVqUgM/HqHrkmb0iZDDF4SfzJXW6mX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)