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