UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9jjTFYZEjPeKoX3wRGM054hs/tgQcQeJ6qcjqn4J7UA='
WHERE
key_id = '42200a002f57050fd43454077ffcf549627e72d67e517da17b07cdb49f83769a'
AND (
token = '9jjTFYZEjPeKoX3wRGM054hs/tgQcQeJ6qcjqn4J7UA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)