UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gJq3aifTOjMViY1cMabbgBawmeLYqDUAoncVL1/8eAo='
WHERE
key_id = 'b28768df0274bfe1cf77b74707b47ed714735d09e6ad4e09244d34d8c803b487'
AND (
token = 'gJq3aifTOjMViY1cMabbgBawmeLYqDUAoncVL1/8eAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)