UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4fRu3J5gaL0IzdqduahYZtjL7gdYJSJTLoeE8INTGTY='
WHERE
key_id = 'd6802c97f37461a94e640e5d4ed43c824b092fbc1cbb4afeb03d267aa4742791'
AND (
token = '4fRu3J5gaL0IzdqduahYZtjL7gdYJSJTLoeE8INTGTY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)