UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N5JWp6HTyWNdkzerZd3sLAb3dX8ItUkGIpOep8W6c78='
WHERE
key_id = '117c2a295e315f1697a8b11aa766617e26a9d144bbd633458d02faff9f0be9a3'
AND (
token = 'N5JWp6HTyWNdkzerZd3sLAb3dX8ItUkGIpOep8W6c78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)