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