UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mch0Q+mN77xRggSfzE9Iit1A4Tc47KF/s7iT4RDWMkg='
WHERE
key_id = 'd141c8ac88894f0a02601ba38bbb6e82002ded48cb63b5c5b0be2b5c4177e678'
AND (
token = 'Mch0Q+mN77xRggSfzE9Iit1A4Tc47KF/s7iT4RDWMkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)