UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZN+t+MpW3Xm1omp7Uz/js+9rGM+J1ckFw3BafBYaqc='
WHERE
key_id = '529c1cd505c3ba20f9bc10bd0809e4c091d728a4164dd225870156388573c8f0'
AND (
token = 'XZN+t+MpW3Xm1omp7Uz/js+9rGM+J1ckFw3BafBYaqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)