UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D4qzm1NnUsVTMZqlHtfs3maNUbiIbiyRXgnI2TxESvc='
WHERE
key_id = '2705892deb5f3ba27a1c8fcd873fd192b947d2b030db94d3b93f21970a4e9450'
AND (
token = 'D4qzm1NnUsVTMZqlHtfs3maNUbiIbiyRXgnI2TxESvc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)