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