UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u8hvlCeyaHYuBNP8K13sY9bUiLd3mHevqHp2QOIyWss='
WHERE
key_id = 'a073e4fb60d95c9e64b999787bb902f6b44a1e5ec0c3fb88d0211c0949f1c6c5'
AND (
token = 'u8hvlCeyaHYuBNP8K13sY9bUiLd3mHevqHp2QOIyWss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)