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