UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XpQXj3SJ2robP59H+afbWdl/OhI8nC1Mt4xYsjmiunk='
WHERE
key_id = 'b297db3d2383aeef6443a997d253a905284cfc3432c4a83cf31264df87327c5d'
AND (
token = 'XpQXj3SJ2robP59H+afbWdl/OhI8nC1Mt4xYsjmiunk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)