UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ifd8dOGQyLYhIN8NFeg5Eb1Lp8U/2I+yPgyoJ2WLI7M='
WHERE
key_id = '4926f110b0534ca8345257e1b17326081743b5ccf47bb4cafd74b52fef839c17'
AND (
token = 'Ifd8dOGQyLYhIN8NFeg5Eb1Lp8U/2I+yPgyoJ2WLI7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)