UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8xBQMhVgAAoW/pkhnoeJexVTwgR6mBFg92zj3J5N2Qc='
WHERE
key_id = '9896bd0e542887d3b60744b8ee90bc9afcc0105bfe8ce26d65b34ac0b80ec500'
AND (
token = '8xBQMhVgAAoW/pkhnoeJexVTwgR6mBFg92zj3J5N2Qc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)