UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lnAYIDqiYgD9/jreJL7UXpYNUYoT3viwfPuGyJBJe0E='
WHERE
key_id = 'c0e996efaa509e4f172f305d2c550181ae004b99b0ef9c78b2eda72ae805691b'
AND (
token = 'lnAYIDqiYgD9/jreJL7UXpYNUYoT3viwfPuGyJBJe0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)