UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N/9af0FDMZ9VM7eGTrdELO3fjaTuGAPUYQW6Up+q4K4='
WHERE
key_id = 'bef8f763880571ab8aa43ee69002e5cffb88ab53ce80ab3a53e7821479223be4'
AND (
token = 'N/9af0FDMZ9VM7eGTrdELO3fjaTuGAPUYQW6Up+q4K4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)