UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNC17d7jY2EOXwRRUIZFbe7SVkthkf5Pvepln6Pyp74='
WHERE
key_id = '7842c862d43fea914b1b586ade097501a527c605ca9cdfeff46826af81d134bc'
AND (
token = 'ZNC17d7jY2EOXwRRUIZFbe7SVkthkf5Pvepln6Pyp74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)