UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X67no5cHyKhbWSfWV6eswoCaTwDOWk+k1/NNXienmik='
WHERE
key_id = '7a4d1f0164ff37e14a8c07219e7ae05a467862c0cf13e600e925ea168c0f1d02'
AND (
token = 'X67no5cHyKhbWSfWV6eswoCaTwDOWk+k1/NNXienmik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)