UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0VqOFuXe642UzzwTkrMrS7CUDjUCMDEtdSumLRgsAc0='
WHERE
key_id = '39547bb8d9749af640b74c2a1d447803d50e0900f6a528f01ebccfecf7a30449'
AND (
token = '0VqOFuXe642UzzwTkrMrS7CUDjUCMDEtdSumLRgsAc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)