UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dX/KLb27WpLKULSWlfCO24XsNHQl679wyIR5SuH2R/c='
WHERE
key_id = 'a1a7a980beb33956be20156c4873f7d86fe24c03b84241a095a4fc63027ee222'
AND (
token = 'dX/KLb27WpLKULSWlfCO24XsNHQl679wyIR5SuH2R/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)