UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mN7YjPJxrJB9xRrCxJkasxmcFPBgryUg30daLvEN+x8='
WHERE
key_id = 'ec0c6acd6f1747fc36de5a395591f95685e2d764c6db69891b8ae1ee33fd51bf'
AND (
token = 'mN7YjPJxrJB9xRrCxJkasxmcFPBgryUg30daLvEN+x8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)