UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XNYgTsWy0EgdRNqRNtFeG1Ig9PSk/6MOmYhzbmmrdU8='
WHERE
key_id = '5fb51f1993ff0b1f456a53c583f3c86985a92160b3bae67e1af4e61ce477f2fc'
AND (
token = 'XNYgTsWy0EgdRNqRNtFeG1Ig9PSk/6MOmYhzbmmrdU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)