UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWoOXTmg2XTgE47bMGG8r9xmRURDThSSmWHvtGAIvJA='
WHERE
key_id = '27f370b79002ef78ecaf93e022d217d81187ab799466fc57d2d74187623b98cc'
AND (
token = 'XWoOXTmg2XTgE47bMGG8r9xmRURDThSSmWHvtGAIvJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)