UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kz7PgpXGedOfSGkXCN243BKXXPIHX2Acw+1K0L8J67Q='
WHERE
key_id = 'ab53eacc10e453b7505b59401ea37260cafc795fa7eda24999219817a08aab55'
AND (
token = 'kz7PgpXGedOfSGkXCN243BKXXPIHX2Acw+1K0L8J67Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)