UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ubIz9+HCzOtEh+YQ16P7Ot64+5VJ0HIZBF2jRHy3VR4='
WHERE
key_id = 'ffcdf34f8ab340dcc60132709fc767b732b28feec0f5168c30ee1214e72bc2cc'
AND (
token = 'ubIz9+HCzOtEh+YQ16P7Ot64+5VJ0HIZBF2jRHy3VR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)