UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4x9vi+oIVCoPBo+jFFv2GbnZAUPxW6LQ5vUTFMkLhsU='
WHERE
key_id = '17d21d223299f54739dd219b36f42dd00a9c6948d919e4af8f7346c60a486df9'
AND (
token = '4x9vi+oIVCoPBo+jFFv2GbnZAUPxW6LQ5vUTFMkLhsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)