UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7eW0trK1tR4C1jzMfxmI09wcspVwDg2lGUlON/8wGaE='
WHERE
key_id = '3a180ba80892ab18ab7c1de2f21731607483d7817217bb4bd5c45e592733ed94'
AND (
token = '7eW0trK1tR4C1jzMfxmI09wcspVwDg2lGUlON/8wGaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)