UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9QUqHsKJWn3ZP2zB23Zr6BdzgJ3NgXUKn8NbYojBj0g='
WHERE
key_id = 'cce7ab76d61785287dd426aaa91583661433d90916801757cb38a817e1934292'
AND (
token = '9QUqHsKJWn3ZP2zB23Zr6BdzgJ3NgXUKn8NbYojBj0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)