UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z6QCaOHIxA5d0cgXltP/a34iaG4ub21yTrGiWaomKwY='
WHERE
key_id = 'a67263cbec83b628ec039126d67b526b582189a4bbe19a6d0264332d3cb884e5'
AND (
token = 'z6QCaOHIxA5d0cgXltP/a34iaG4ub21yTrGiWaomKwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)