UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DOTyYMI9tSi5Ypeg4543/JVhCaZs3QGM1BVro/0K3U4='
WHERE
key_id = 'b1f604e67932ba0ec55cb720ed189f5ed6f39e3f3104f1ed9d37b7720ba51b59'
AND (
token = 'DOTyYMI9tSi5Ypeg4543/JVhCaZs3QGM1BVro/0K3U4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)