UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TpEPc8yWfJowG+Qys6b/svdDfW8GBiKFsv52h4+DuC4='
WHERE
key_id = 'df3368ecbea8a797545f1ca92f03e6f1303cf431524a2b4abeb12eefc35bb158'
AND (
token = 'TpEPc8yWfJowG+Qys6b/svdDfW8GBiKFsv52h4+DuC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)